using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class web_pages_ajax_san_ntv_ds_cho_pv : System.Web.UI.Page
{
    public DataTable resdtt;
    Common comm = new Common();
    NguoiTimViecCommon NTVComm = new NguoiTimViecCommon();
    public string ma_san = "";
    public string ma_ntv = "";
  public  SanGDVL sanComm = new SanGDVL();
    protected void Page_Load(object sender, EventArgs e)
    {
        ma_san = Request.QueryString["sid"];
        ma_ntv = NTVComm.getMaNTV(Session["SanNTVuser"].ToString());
        string sql = " select * from viecLamtrong_ho_so_tuyen_dung " +
                     " where ma_ho_so in (select ma_vlt from SanGiaoDich_nop_ho_so " +
                     " where ma_san ='" + ma_san + "' and ma_ntv = '" + NTVComm.getMaNTV(Session["SanNTVuser"].ToString()) + "' and duyet = 1 ) ";
        resdtt = comm.getDataTable(sql);
    }
}
